/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.1.83
 Source Server Type    : SQL Server
 Source Server Version : 10504000
 Source Host           : Desktop-mqo4kpd:1433
 Source Catalog        : Draw
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 10504000
 File Encoding         : 65001

 Date: 24/09/2020 18:02:07
*/


-- ----------------------------
-- Table structure for Node
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Node]') AND type IN ('U'))
	DROP TABLE [dbo].[Node]
GO

CREATE TABLE [dbo].[Node] (
  [Id] int  IDENTITY(1,1) NOT NULL,
  [NodeName] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ParentId] int  NULL,
  [DrawNum] int  NULL,
  [IsParent] int  NULL
)
GO

ALTER TABLE [dbo].[Node] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of Node
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Node] ON
GO

INSERT INTO [dbo].[Node] ([Id], [NodeName], [ParentId], [DrawNum], [IsParent]) VALUES (N'1', N'技术资料', N'0', N'1', N'1')
GO

INSERT INTO [dbo].[Node] ([Id], [NodeName], [ParentId], [DrawNum], [IsParent]) VALUES (N'3', N'技术说明书', N'1', N'1', N'1')
GO

INSERT INTO [dbo].[Node] ([Id], [NodeName], [ParentId], [DrawNum], [IsParent]) VALUES (N'4', N'整机使用说明书', N'3', N'1', N'0')
GO

INSERT INTO [dbo].[Node] ([Id], [NodeName], [ParentId], [DrawNum], [IsParent]) VALUES (N'5', N'整机通讯使用手册', N'3', N'2', N'0')
GO

INSERT INTO [dbo].[Node] ([Id], [NodeName], [ParentId], [DrawNum], [IsParent]) VALUES (N'17', N'技术计算手册', N'1', N'2', N'1')
GO

INSERT INTO [dbo].[Node] ([Id], [NodeName], [ParentId], [DrawNum], [IsParent]) VALUES (N'18', N'尺寸链', N'17', N'1', N'0')
GO

INSERT INTO [dbo].[Node] ([Id], [NodeName], [ParentId], [DrawNum], [IsParent]) VALUES (N'19', N'电机仿真图', N'17', N'2', N'0')
GO

INSERT INTO [dbo].[Node] ([Id], [NodeName], [ParentId], [DrawNum], [IsParent]) VALUES (N'20', N'PCB仿真图', N'17', N'3', N'0')
GO

INSERT INTO [dbo].[Node] ([Id], [NodeName], [ParentId], [DrawNum], [IsParent]) VALUES (N'22', N'电路', N'0', N'2', N'1')
GO

INSERT INTO [dbo].[Node] ([Id], [NodeName], [ParentId], [DrawNum], [IsParent]) VALUES (N'30', N'明细表', N'1', N'3', N'0')
GO

INSERT INTO [dbo].[Node] ([Id], [NodeName], [ParentId], [DrawNum], [IsParent]) VALUES (N'31', N'整机明细表', N'30', N'1', N'0')
GO

INSERT INTO [dbo].[Node] ([Id], [NodeName], [ParentId], [DrawNum], [IsParent]) VALUES (N'35', N'性能表', N'1', N'4', N'0')
GO

INSERT INTO [dbo].[Node] ([Id], [NodeName], [ParentId], [DrawNum], [IsParent]) VALUES (N'36', N'整机性能表', N'35', N'1', N'0')
GO

INSERT INTO [dbo].[Node] ([Id], [NodeName], [ParentId], [DrawNum], [IsParent]) VALUES (N'37', N'外形图', N'1', N'5', N'0')
GO

INSERT INTO [dbo].[Node] ([Id], [NodeName], [ParentId], [DrawNum], [IsParent]) VALUES (N'38', N'整机外形图', N'37', N'1', N'0')
GO

INSERT INTO [dbo].[Node] ([Id], [NodeName], [ParentId], [DrawNum], [IsParent]) VALUES (N'39', N'程序', N'0', N'3', N'1')
GO

INSERT INTO [dbo].[Node] ([Id], [NodeName], [ParentId], [DrawNum], [IsParent]) VALUES (N'44', N'工程PCB', N'22', N'1', N'0')
GO

INSERT INTO [dbo].[Node] ([Id], [NodeName], [ParentId], [DrawNum], [IsParent]) VALUES (N'45', N'新增', N'22', N'2', N'0')
GO

INSERT INTO [dbo].[Node] ([Id], [NodeName], [ParentId], [DrawNum], [IsParent]) VALUES (N'46', N'PCB原理图', N'44', N'1', N'0')
GO

INSERT INTO [dbo].[Node] ([Id], [NodeName], [ParentId], [DrawNum], [IsParent]) VALUES (N'47', N'新增节点', N'1', N'6', N'0')
GO

SET IDENTITY_INSERT [dbo].[Node] OFF
GO


-- ----------------------------
-- Table structure for t_d_DrawCombo
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_d_DrawCombo]') AND type IN ('U'))
	DROP TABLE [dbo].[t_d_DrawCombo]
GO

CREATE TABLE [dbo].[t_d_DrawCombo] (
  [Id] int  IDENTITY(1,1) NOT NULL,
  [DrawDetailId] int  NULL,
  [ParentId] int  NULL,
  [SerialDrawName] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MotorId] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ComboId] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IsDelete] int  NULL,
  [IncreaseNum] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [SerialDrawNum] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [InstallNum] int  NULL,
  [Memo] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[t_d_DrawCombo] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of t_d_DrawCombo
-- ----------------------------
SET IDENTITY_INSERT [dbo].[t_d_DrawCombo] ON
GO

INSERT INTO [dbo].[t_d_DrawCombo] ([Id], [DrawDetailId], [ParentId], [SerialDrawName], [MotorId], [ComboId], [IsDelete], [IncreaseNum], [SerialDrawNum], [InstallNum], [Memo]) VALUES (N'151', N'48', N'0', N'PCB仿真图', N'test2', N'20200924172405', N'0', N'001', N'123', N'0', N'test2')
GO

INSERT INTO [dbo].[t_d_DrawCombo] ([Id], [DrawDetailId], [ParentId], [SerialDrawName], [MotorId], [ComboId], [IsDelete], [IncreaseNum], [SerialDrawNum], [InstallNum], [Memo]) VALUES (N'152', N'47', N'0', N'电机仿真图', N'test2', N'20200924172451', N'0', N'001', N'122', N'0', N'test2')
GO

INSERT INTO [dbo].[t_d_DrawCombo] ([Id], [DrawDetailId], [ParentId], [SerialDrawName], [MotorId], [ComboId], [IsDelete], [IncreaseNum], [SerialDrawNum], [InstallNum], [Memo]) VALUES (N'153', N'49', N'0', N'PCB原理图', N'ces ', N'20200924172650', N'0', N'001', N'211', N'0', N'ces ')
GO

INSERT INTO [dbo].[t_d_DrawCombo] ([Id], [DrawDetailId], [ParentId], [SerialDrawName], [MotorId], [ComboId], [IsDelete], [IncreaseNum], [SerialDrawNum], [InstallNum], [Memo]) VALUES (N'154', N'44', N'151', N'整机使用说明书', N'test1', N'20200924172405', N'0', N'001', N'111', N'1', NULL)
GO

INSERT INTO [dbo].[t_d_DrawCombo] ([Id], [DrawDetailId], [ParentId], [SerialDrawName], [MotorId], [ComboId], [IsDelete], [IncreaseNum], [SerialDrawNum], [InstallNum], [Memo]) VALUES (N'155', N'49', N'154', N'PCB原理图', N'ces ', N'20200924172405', N'0', N'001', N'211', N'0', NULL)
GO

INSERT INTO [dbo].[t_d_DrawCombo] ([Id], [DrawDetailId], [ParentId], [SerialDrawName], [MotorId], [ComboId], [IsDelete], [IncreaseNum], [SerialDrawNum], [InstallNum], [Memo]) VALUES (N'156', N'48', N'154', N'PCB仿真图', N'test2', N'20200924172405', N'1', N'001', N'123', N'0', NULL)
GO

INSERT INTO [dbo].[t_d_DrawCombo] ([Id], [DrawDetailId], [ParentId], [SerialDrawName], [MotorId], [ComboId], [IsDelete], [IncreaseNum], [SerialDrawNum], [InstallNum], [Memo]) VALUES (N'157', N'44', N'156', N'整机使用说明书', N'test1', N'20200924172405', N'1', N'001', N'111', N'1', NULL)
GO

INSERT INTO [dbo].[t_d_DrawCombo] ([Id], [DrawDetailId], [ParentId], [SerialDrawName], [MotorId], [ComboId], [IsDelete], [IncreaseNum], [SerialDrawNum], [InstallNum], [Memo]) VALUES (N'158', N'49', N'157', N'PCB原理图', N'ces ', N'20200924172405', N'0', N'001', N'211', N'0', NULL)
GO

SET IDENTITY_INSERT [dbo].[t_d_DrawCombo] OFF
GO


-- ----------------------------
-- Table structure for t_d_DrawDetail
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_d_DrawDetail]') AND type IN ('U'))
	DROP TABLE [dbo].[t_d_DrawDetail]
GO

CREATE TABLE [dbo].[t_d_DrawDetail] (
  [Id] int  IDENTITY(1,1) NOT NULL,
  [UserId] int  NULL,
  [SerialDrawName] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [SerialDrawNum] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [GetTime] datetime  NULL,
  [IncreaseNum] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IsDelete] int  NULL,
  [MotorId] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [Memo] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [Type] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[t_d_DrawDetail] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of t_d_DrawDetail
-- ----------------------------
SET IDENTITY_INSERT [dbo].[t_d_DrawDetail] ON
GO

INSERT INTO [dbo].[t_d_DrawDetail] ([Id], [UserId], [SerialDrawName], [SerialDrawNum], [GetTime], [IncreaseNum], [IsDelete], [MotorId], [Memo], [Type]) VALUES (N'44', N'4', N'整机使用说明书', N'111', N'2020-09-24 15:56:25.000', N'001', N'0', N'test1', N'test', N'零部件')
GO

INSERT INTO [dbo].[t_d_DrawDetail] ([Id], [UserId], [SerialDrawName], [SerialDrawNum], [GetTime], [IncreaseNum], [IsDelete], [MotorId], [Memo], [Type]) VALUES (N'45', N'4', N'整机通讯使用手册', N'112', N'2020-09-24 15:56:33.000', N'001', N'0', N'test1', N'test', N'零部件')
GO

INSERT INTO [dbo].[t_d_DrawDetail] ([Id], [UserId], [SerialDrawName], [SerialDrawNum], [GetTime], [IncreaseNum], [IsDelete], [MotorId], [Memo], [Type]) VALUES (N'46', N'4', N'尺寸链', N'121', N'2020-09-24 15:56:38.000', N'001', N'0', N'test1', N'test', N'零部件')
GO

INSERT INTO [dbo].[t_d_DrawDetail] ([Id], [UserId], [SerialDrawName], [SerialDrawNum], [GetTime], [IncreaseNum], [IsDelete], [MotorId], [Memo], [Type]) VALUES (N'47', N'4', N'电机仿真图', N'122', N'2020-09-24 15:56:46.000', N'001', N'0', N'test2', N'test2', N'组件')
GO

INSERT INTO [dbo].[t_d_DrawDetail] ([Id], [UserId], [SerialDrawName], [SerialDrawNum], [GetTime], [IncreaseNum], [IsDelete], [MotorId], [Memo], [Type]) VALUES (N'48', N'4', N'PCB仿真图', N'123', N'2020-09-24 15:57:14.000', N'001', N'0', N'test2', N'test2', N'组件')
GO

INSERT INTO [dbo].[t_d_DrawDetail] ([Id], [UserId], [SerialDrawName], [SerialDrawNum], [GetTime], [IncreaseNum], [IsDelete], [MotorId], [Memo], [Type]) VALUES (N'49', N'4', N'PCB原理图', N'211', N'2020-09-24 17:26:21.000', N'001', N'0', N'ces ', N'ces ', N'组件')
GO

SET IDENTITY_INSERT [dbo].[t_d_DrawDetail] OFF
GO


-- ----------------------------
-- Table structure for t_d_User
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_d_User]') AND type IN ('U'))
	DROP TABLE [dbo].[t_d_User]
GO

CREATE TABLE [dbo].[t_d_User] (
  [Id] int  IDENTITY(1,1) NOT NULL,
  [UserName] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [PassWord] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [role] int  NULL,
  [IsDelete] int  NULL
)
GO

ALTER TABLE [dbo].[t_d_User] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of t_d_User
-- ----------------------------
SET IDENTITY_INSERT [dbo].[t_d_User] ON
GO

INSERT INTO [dbo].[t_d_User] ([Id], [UserName], [PassWord], [role], [IsDelete]) VALUES (N'3', N'季桂德', N'123456', N'1', N'0')
GO

INSERT INTO [dbo].[t_d_User] ([Id], [UserName], [PassWord], [role], [IsDelete]) VALUES (N'4', N'管理员', N'123456', N'1', N'0')
GO

INSERT INTO [dbo].[t_d_User] ([Id], [UserName], [PassWord], [role], [IsDelete]) VALUES (N'5', N'sdf', NULL, NULL, N'1')
GO

INSERT INTO [dbo].[t_d_User] ([Id], [UserName], [PassWord], [role], [IsDelete]) VALUES (N'6', N'ffff', NULL, N'2', N'1')
GO

INSERT INTO [dbo].[t_d_User] ([Id], [UserName], [PassWord], [role], [IsDelete]) VALUES (N'7', N'cc', N'123456', N'1', N'1')
GO

INSERT INTO [dbo].[t_d_User] ([Id], [UserName], [PassWord], [role], [IsDelete]) VALUES (N'8', N'ces ', N'123456', N'2', N'1')
GO

INSERT INTO [dbo].[t_d_User] ([Id], [UserName], [PassWord], [role], [IsDelete]) VALUES (N'9', N'test', N'123456', N'2', N'0')
GO

SET IDENTITY_INSERT [dbo].[t_d_User] OFF
GO


-- ----------------------------
-- Table structure for T_LOG
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[T_LOG]') AND type IN ('U'))
	DROP TABLE [dbo].[T_LOG]
GO

CREATE TABLE [dbo].[T_LOG] (
  [LogId] int  IDENTITY(1,1) NOT NULL,
  [Type] int  NULL,
  [OpLog] text COLLATE Chinese_PRC_CI_AS  NULL,
  [OpTime] datetime  NULL,
  [OpID] int  NULL
)
GO

ALTER TABLE [dbo].[T_LOG] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of T_LOG
-- ----------------------------
SET IDENTITY_INSERT [dbo].[T_LOG] ON
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'1', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:1 附近有语法错误。', N'2020-09-16 11:01:57.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'2', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:关键字 CONVERT 附近有语法错误。', N'2020-09-16 15:07:21.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'3', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:关键字 CONVERT 附近有语法错误。', N'2020-09-16 15:07:57.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'4', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:列名 IsDelete 不明确。
列名 id 不明确。', N'2020-09-16 15:08:23.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'5', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:列名 id 不明确。', N'2020-09-16 15:09:11.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'6', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:列名 id 不明确。', N'2020-09-16 15:10:20.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'7', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:列名 IsDelete 不明确。
列名 Id 不明确。', N'2020-09-16 16:16:43.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'8', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:列名 IsDelete 不明确。
列名 Id 不明确。', N'2020-09-16 16:17:07.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'9', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:列名 IsDelete 不明确。
列名 Id 不明确。', N'2020-09-16 16:17:07.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'10', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:列名 IsDelete 不明确。
列名 Id 不明确。', N'2020-09-16 16:17:08.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'11', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:列名 IsDelete 不明确。', N'2020-09-16 16:20:45.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'12', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:列名 IsDelete 不明确。', N'2020-09-16 16:21:23.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'13', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:列名 IsDelete 不明确。', N'2020-09-16 16:21:42.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'14', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:列名 IsDelete 不明确。', N'2020-09-16 16:22:34.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'15', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:（ 附近有语法错误。', N'2020-09-17 10:10:33.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'16', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:（ 附近有语法错误。', N'2020-09-17 10:10:51.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'17', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:（ 附近有语法错误。', N'2020-09-17 10:14:47.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'18', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:无法绑定由多个部分组成的标识符 "a.IsDelete"。
无法绑定由多个部分组成的标识符 "a.Id"。', N'2020-09-17 17:02:19.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'19', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:无法绑定由多个部分组成的标识符 "a.IsDelete"。
无法绑定由多个部分组成的标识符 "a.Id"。', N'2020-09-17 17:02:55.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'20', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:关键字 desc 附近有语法错误。', N'2020-09-23 22:42:23.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'21', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:关键字 desc 附近有语法错误。', N'2020-09-23 22:42:30.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'22', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:关键字 desc 附近有语法错误。', N'2020-09-23 22:42:31.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'23', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:关键字 desc 附近有语法错误。', N'2020-09-23 22:42:31.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'24', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:关键字 desc 附近有语法错误。', N'2020-09-23 22:42:31.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'25', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:关键字 desc 附近有语法错误。', N'2020-09-23 22:42:32.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'26', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:关键字 desc 附近有语法错误。', N'2020-09-23 22:42:32.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'27', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:关键字 desc 附近有语法错误。', N'2020-09-23 22:42:32.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'28', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:关键字 desc 附近有语法错误。', N'2020-09-23 22:42:32.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'29', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:关键字 desc 附近有语法错误。', N'2020-09-23 22:42:50.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'30', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:关键字 desc 附近有语法错误。', N'2020-09-23 22:44:01.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'31', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:关键字 desc 附近有语法错误。', N'2020-09-23 22:44:08.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'32', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:) 附近有语法错误。', N'2020-09-23 23:00:09.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'33', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:) 附近有语法错误。', N'2020-09-23 23:02:45.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'34', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:) 附近有语法错误。', N'2020-09-23 23:03:52.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'35', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:) 附近有语法错误。', N'2020-09-23 23:06:04.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'36', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:列名 Type 无效。', N'2020-09-24 17:20:55.000', N'1')
GO

INSERT INTO [dbo].[T_LOG] ([LogId], [Type], [OpLog], [OpTime], [OpID]) VALUES (N'37', N'1', N'异常：加载需求管理表格异常 /UserController/UserTableRequest:列名 Type 无效。', N'2020-09-24 17:21:20.000', N'1')
GO

SET IDENTITY_INSERT [dbo].[T_LOG] OFF
GO


-- ----------------------------
-- Table structure for test
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[test]') AND type IN ('U'))
	DROP TABLE [dbo].[test]
GO

CREATE TABLE [dbo].[test] (
  [Id] int  IDENTITY(1,1) NOT NULL,
  [textval] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[test] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of test
-- ----------------------------
SET IDENTITY_INSERT [dbo].[test] ON
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'1', N'aaa')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'2', N'aaa')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'3', N'aaa')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'4', N'aaa')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'5', N'aaa')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'6', N'aaa')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'7', N'aaa')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'8', N'aaa')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'9', N'aaa')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'10', N'aaa')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'11', N'aaa1')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'12', N'aaa1')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'13', N'aaa1')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'14', N'aaa1')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'15', N'aaa1')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'16', N'aaa1')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'17', N'aaa1')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'18', N'aaa1')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'19', N'aaa1')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'20', N'aaa1')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'21', N'aaa1')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'22', N'aaa1')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'23', N'aaa1')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'24', N'aaa1')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'25', N'aaa1')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'26', N'aaa1')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'27', N'ttttt')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'28', N'ttttt')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'29', N'ttttt')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'30', N'ttttt')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'31', N'ttttt')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'32', N'ttttt')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'33', N'ttttt')
GO

INSERT INTO [dbo].[test] ([Id], [textval]) VALUES (N'34', N'ttttt')
GO

SET IDENTITY_INSERT [dbo].[test] OFF
GO


-- ----------------------------
-- Primary Key structure for table Node
-- ----------------------------
ALTER TABLE [dbo].[Node] ADD CONSTRAINT [PK__Node__3214EC0703317E3D] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table t_d_DrawCombo
-- ----------------------------
ALTER TABLE [dbo].[t_d_DrawCombo] ADD CONSTRAINT [PK__t_d_Draw__3214EC071273C1CD] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table t_d_DrawDetail
-- ----------------------------
ALTER TABLE [dbo].[t_d_DrawDetail] ADD CONSTRAINT [PK__t_d_Draw__3214EC070EA330E9] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table t_d_User
-- ----------------------------
ALTER TABLE [dbo].[t_d_User] ADD CONSTRAINT [PK__t_d_User__3214EC0707020F21] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table T_LOG
-- ----------------------------
ALTER TABLE [dbo].[T_LOG] ADD CONSTRAINT [PK__T_LOG__5E5486480AD2A005] PRIMARY KEY CLUSTERED ([LogId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table test
-- ----------------------------
ALTER TABLE [dbo].[test] ADD CONSTRAINT [PK__test__3214EC07164452B1] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

